/**
*┌──────────────────────────────────────────────────────────────┐
*│　描    述：SysUser仓储接口                                                   
*│　作    者：sys                                              
*│　创建时间：2020-11-06 14:41:01  
*│　说    明：代码生成器生成   
*└──────────────────────────────────────────────────────────────┘
*/
using SXFramWork.Core;
using SXFramWork.Model;
using System;
using System.Collections.Generic;
using System.Data;
using System.Threading.Tasks;

namespace SXFramWork.Repository
{
    public interface ISysUserRepository : IRepository<SysUserEntity>
    {
        /// <summary>
        /// 根据名称查询账户
        /// </summary>
        /// <param name="UserName"></param>
        /// <returns></returns>
        Task<SysUserEntity> GetUserByNameAsync(string UserName);

        Task<List<SysUserEntity>> Query(UserQueryModel model);
        /// <summary>
        /// 查询user信息Excel
        /// </summary>
        /// <returns></returns>
        Task<List<UserExcelModel>> GetUserInfoExcel();
        /// <summary>
        /// 插入datatable的数据
        /// </summary>
        /// <param name="tb"></param>
        /// <returns></returns>
        Task<int> AddDTable(DataTable tb);
    }
}